import { Knex} from "knex";
import {CDM_RUNTIME_SCHEMA} from "../../../utils/globals"

export function up(knex: Knex) {
    return knex.schema
    .raw(`INSERT INTO "${CDM_RUNTIME_SCHEMA}"."WorkPage" ("Id", "TenantId", "CreatedAt", "DescriptorSchemaId", "DescriptorSchemaVersion", "Descriptor", "Editable", "IsDefault", "CurrentVersionId", "Draft", "Versions", "InstanceId") VALUES
    ('ee9802df-615b-48b0-a60d-44db00674620', '9f77a69d-5d71-48b4-b759-93616a3d60f6', '2022-03-20 17:53:14.698569+00', NULL, '1.0', '{ "sap.ui": {"name": {"newName": "test"}}}', 'f', 'f', '1', NULL, NULL, '1d59c4d7-5985-4f21-ad3c-1ac66bf14d2b');`)

    .raw(`INSERT INTO "${CDM_RUNTIME_SCHEMA}"."WorkPageVersion" ("Id", "TenantId", "Contents", "PublishedTimestamp", "PublishedByUser", "WorkPageId", "CreatedAt", "BaselineVersionId", "InstanceId") VALUES
    ('2d9b945a-5d7a-4914-b51a-6f0886ff3973', '9f77a69d-5d71-48b4-b759-93616a3d60f6', '{
      "WorkPage": {
        "ID": "70b3aa12-ce74-4b22-83c3-f6e1f801adbf",
        "Descriptor": {
          "Title": "",
          "sap.ui": {
            "name": {
              "newName": "test"
            }
          }
        }
      }
    }', '2021-12-17 02:00:54.737', 'admin', 'ee9802df-615b-48b0-a60d-44db00674620', '2022-03-20 18:15:50.511405+00', '1', '1d59c4d7-5985-4f21-ad3c-1ac66bf14d2b');`);
}

export function down(knex: Knex) {
    return knex.schema.raw(`DROP SCHEMA IF EXISTS "${CDM_RUNTIME_SCHEMA}" CASCADE;`);
}